SQL QueRIE Recommendations

The QueRIE system for Personalized Query Recommendations

Interactive database exploration is a key task in information mining. However, users who lack SQL expertise or familiarity with the database schema face great difficulties in performing this task. To aid these users, we developed the QueRIE system for personalized query recommendations. QueRIE continuously monitors the user’s querying behavior and finds matching patterns in the system’s query l...

SQL QueRIE Recommendations: a query fragment-based approach

Relational database systems are becoming increasingly popular in the scientific community to support the interactive exploration of large volumes of data. In this scenario, users employ a query interface (typically, a web-based client) to issue a series of SQL queries that aim to analyze the data and mine it for interesting information. First-time users, however, may not have the necessary know...

More Like This: Query Recommendations for SQL

Unicode Identifiers : an SQL Example

While any standards body is free to define their standard as they wish, it is clear that the Unicode consortium can have a positive effect on uniformity and quality on other standards. The purpose of this paper is to stimulate discussion towards a set of recommendations concerning identifiers. I use the SQL-99 standard as an example source for such issues, not because it is either good or bad, ...

Teaching SQL - Which Pedagogical Horse for This Course?

A student with a Computing Science degree is expected to have reached a reasonable level of expertise in SQL. SQL is a non-trivial skill to master and is taught with different degrees of success at different institutions. When teaching any skill we have to take both previous learning and experience into consideration as well as the best possible way of teaching the skill. When learning a new sk...